How to: Remove the primary key feature from a field in a table.
Solution:
In the Table Design view, select the field that is currently set as the primary key, and select the 'Edit' menu and select 'Primary Key'.
NOTE 1: When a key is set as the primary key, a check mark appears next to 'Primary Key' under the 'Edit' menu. Make sure there is NO check mark, for the primary key to be removed.
NOTE 2: At times, the primary key feature may have to be removed for a table. For example, since importing records into a table could result in duplicates, the primary key should be removed.
NOTE 3: Removing the primary key feature for a table does NOT delete the field with that feature.
NOTE 4: The primary key property sometimes cannot be removed because the selected table is the primary table in one or more relationships. That relationship(s) must be deleted in the Relationships window BEFORE the primary key property can be removed.
